USE [Training]
GO

IF NOT EXISTS (SELECT * from dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.training_api_TrainingRecordSelectByRecordID'))
	EXEC('CREATE PROC dbo.training_api_TrainingRecordSelectByRecordID AS')
GO

ALTER PROC dbo.training_api_TrainingRecordSelectByRecordID
	@TrainingRecordID	int
AS
	SELECT
		TrainingRecordID,
		EmployeeID,
		DueDate,
		CompletedDate,
		SkillID
	FROM
		TrainingRecord
	WHERE
		TrainingRecordID = @TrainingRecordID

